﻿    /***************************************************************************************************
    **  Table:	    public.role_feature
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered role feature.
    **    
    **    Use the following queries to find availables accounts and applicable roles
    **    SELECT * FROM role;
    **    SELECT * FROM feature;
    **    
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 1);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 2);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 3);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 4);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 5);

    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 6);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 7);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 8);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 9);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 10);

    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 11);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 12);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 13);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 14);
    INSERT INTO public.role_feature (role_id, feature_id) VALUES (1, 15);
    


	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.role_feature;


